<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
        <title>Our Partner</title>

    </head>
    <body>
        <?php
        include('inc/init.php');

        $smarty->template_dir = 'templates';
        $smarty->assign('title', $title);

        $partners = $db->prepare("select * from ats_partners");
        $partners->execute();
        $partners->setFetchMode(PDO::FETCH_LAZY);

        $cities = $db->prepare("select distinct city, cityname from ats_partners order by cityname");
        $cities->execute();
        $cities->setFetchMode(PDO::FETCH_ASSOC);

        $smarty->assign('partners', $partners);
        $smarty->assign('cities', $cities);

        $smarty->display('partners.tpl');
        ?>
    </body>
</html>